why an int datatype variable accept a string format value in stored procedure in SQL Server.

Question

Ashutosh Kumar Verma · Answer

Passing a number in string format to an integer variable in a stored procedure :
and  and  When pass a value to integer datatype variable in the form of string value then that accept it because after accept first that value is implicitly CAST to an integer then the value is assigning to the parameter.
and  and  Ex- If we pass an integer value as ' 145 ' to integer type parameter then it implicitly CAST to an integer type value successfully in 145 then it assigned to the parameter of stored procedure then the statement is work file.
and  and  I have create a Stored Procedure with two parameters,
and  and  create procedure sp_Demo(@ID int,@Name varchar(255))ASand --SQL Statement
and  and  We pass Value to parameter of above stored procedure like-
EXEC sp_Demo@ID=145,@Name=' Radhe Krishna ' ;
The above procedure work file.
If we pass the value ' 145' instead of 145 to @ID parameter and ' Radhe Krishna ' to @Name parameter then also that procedure execute fine because before accepting the value to parameter that value will CAST first to the parameters datatype then assign to the parameters so stored procedure work fine and execute.
Noteand -and  and  and CASTand  is function to convert one datatype value in other datatype value. CONVERT() is also used for same purpose.

forum

why an int datatype variable accept a string format value in stored procedure in SQL Server.

Ravi Vishwakarma

Can you answer this question?

1 Answers

Liked By